package com.sunjian.dao.db2;

import com.sunjian.entity.House;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.beans.factory.annotation.Qualifier;

import java.util.List;

/**
 * @author sunjian
 * @date 2021/12/2 21:55
 */
@Mapper
@Qualifier("db2SqlSessionTemplate")
public interface HouseDao {
    @Select("SELECT * FROM house")
    List<House> queryAllHouse();
    @Select("SELECT * FROM house WHERE id = #{id}")
    House findMoneyById(@Param("id") int id);
}
